Tabela Patient

Definicja tabeli Patient

Name

Patient

Code

Patient

Comment

 


Lista kolumn tabeli Patient

Name

Code

ID

ID

ExtID

ExtID

NationalID

NationalID

FirstName

FirstName

LastName

LastName

DateOB

DateOB

Sex

Sex

Address

Address

OwnerID

OwnerID

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

FullAcc

FullAcc

ReadAcc

ReadAcc

MaidenName

MaidenName


Kolumna ID tabeli Patient

Definicja kolumny ID tabeli Patient

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExtID tabeli Patient

Definicja kolumny ExtID tabeli Patient

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna NationalID tabeli Patient

Definicja kolumny NationalID tabeli Patient

Name

NationalID

Code

NationalID

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna FirstName tabeli Patient

Definicja kolumny FirstName tabeli Patient

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna LastName tabeli Patient

Definicja kolumny LastName tabeli Patient

Name

LastName

Code

LastName

Data Type

VARCHAR2(30)

Mandatory

No

Comment

 


Kolumna DateOB tabeli Patient

Definicja kolumny DateOB tabeli Patient

Name

DateOB

Code

DateOB

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Sex tabeli Patient

Definicja kolumny Sex tabeli Patient

Name

Sex

Code

Sex

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna Address tabeli Patient

Definicja kolumny Address tabeli Patient

Name

Address

Code

Address

Data Type

VARCHAR2(250)

Mandatory

No

Comment

 


Kolumna OwnerID tabeli Patient

Definicja kolumny OwnerID tabeli Patient

Name

OwnerID

Code

OwnerID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UpdUserID tabeli Patient

Definicja kolumny UpdUserID tabeli Patient

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli Patient

Definicja kolumny UpdNr tabeli Patient

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli Patient

Definicja kolumny UpdDate tabeli Patient

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli Patient

Definicja kolumny UpdTime tabeli Patient

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli Patient

Definicja kolumny LockUserID tabeli Patient

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli Patient

Definicja kolumny LockTime tabeli Patient

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FullAcc tabeli Patient

Definicja kolumny FullAcc tabeli Patient

Name

FullAcc

Code

FullAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna ReadAcc tabeli Patient

Definicja kolumny ReadAcc tabeli Patient

Name

ReadAcc

Code

ReadAcc

Data Type

RAW(255)

Mandatory

No

Comment

 


Kolumna MaidenName tabeli Patient

Definicja kolumny MaidenName tabeli Patient

Name

MaidenName

Code

MaidenName

Data Type

VARCHAR2(80)

Mandatory

No

Comment

 


Lista kluczy tabeli Patient

Name

Code

Primary

Patient_ID_10400067361

Patient_ID_10400067361

X


Klucz Patient_ID_10400067361 tabeli Patient

Definicja klucza Patient_ID_10400067361 tabeli Patient

Name

Patient_ID_10400067361

Code

Patient_ID_10400067361

Primary

Yes

Comment